IF NOT EXISTS(SELECT * FROM sys.sysobjects WHERE name ='STITransaction' and xtype='U')
Begin

CREATE TABLE [dbo].[STITransaction](
	[Id] [UNIQUEIDENTIFIER] NOT NULL DEFAULT (NEWID()),
	[InvoiceId] [BIGINT] NOT NULL,
	[Type] [SMALLINT] NOT NULL,
	[Status] [TINYINT] NOT NULL DEFAULT ((0)),
	[ResultMessage] [NVARCHAR](MAX) NULL,
	[ErrorCode] [INT] NULL,
	[JsonResult] [NVARCHAR](MAX) NULL,
	[ResultDate] [DATETIME] NULL,
	[ResultId] [VARCHAR](MAX) NULL,
	[ResultInvoiceNo] [VARCHAR](MAX) NULL,
	[CreatedOn] [DATETIME] NULL  DEFAULT (GETDATE()),
	[CreatedBy] [SMALLINT] NULL,
 CONSTRAINT [PK_STITransaction] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
) ON [PRIMARY]
) 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'0 is Unsent,1 is Sent And Success, 2 Sent And Failed,3 Sending Failed(Connection Error),4 is Sent And Pending' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'STITransaction', @level2type=N'COLUMN',@level2name=N'Status'
END